/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.yunhoo.govProcure.db.dao;

import com.yunhoo.govProcure.model.CateDataModel;
import com.yunhoo.govProcure.model.CateEditBase;
import com.yunhoo.govProcure.model.CateEditDetail;
import com.yunhoo.govProcure.model.ExecuteAppend;
import java.sql.SQLException;
import java.util.List;

/**
 *
 * @author Administrator
 */
public interface ProcureExecEditDao {

    public List<String> queryAllCategroyStandardCode();

    public List<CateDataModel> queryCategroyStandardByCategoryCode(String categoryCode);

    public CateEditBase queryCateBase(CateEditBase param);

    public CateEditBase queryCateBaseByNumber(CateEditBase param);

    public ExecuteAppend queryExecuteAppend(ExecuteAppend param);

    public List<CateEditBase> queryListCateBase(CateEditBase param);

    public List<CateEditDetail> queryListCateDetailByNumber(CateEditDetail param);

    public List<CateEditDetail> queryListCateDetailForCheck(CateEditDetail param);

    public void insertExecBase(CateEditBase param) throws SQLException;

    public void insertExecDetail(CateEditDetail param) throws SQLException;

    public void insertExecuteAppend(ExecuteAppend param) throws SQLException;

    //public void updateExecBase(CateEditBase param) throws SQLException;
    public void updateExecDetail(CateEditDetail param) throws SQLException;

    public void updateExecuteAppend(ExecuteAppend param) throws SQLException;

    public void deleteExecBase(CateEditBase param) throws SQLException;

    public void deleteExecDetail(CateEditDetail param) throws SQLException;

    public void deleteExecuteAppend(ExecuteAppend param) throws SQLException;

    public Integer queryMaxNumberFromExecBase(CateEditBase param);

    public Integer queryMaxNumberFromExecuteAppend(ExecuteAppend param);
}
